--restricteduielements_roleprivileges

--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('AASS Overdue','Actionable Alerts');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (1,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (1,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (1,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (1,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (1,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (1,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Donor Award Ending','Actionable Alerts');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (2,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (2,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (2,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (2,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (2,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (2,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Final Audit Past Due','Actionable Alerts');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (3,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (3,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (3,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (3,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (3,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (3,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Financial Report Past Due','Actionable Alerts');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (4,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (4,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (4,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (4,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (4,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (4,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Grant End Date Changed','Change Notifications');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (5,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (5,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (5,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (5,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (5,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (5,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Grant Start Date Changed','Change Notifications');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (6,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (6,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (6,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (6,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (6,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (6,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Grant Status Changed','Change Notifications');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (7,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (7,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (7,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (7,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (7,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (7,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Interim Audit Past Due','Actionable Alerts');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (8,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (8,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (8,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (8,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (8,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (8,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Narrative Report Past Due','Actionable Alerts');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (9,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (9,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (9,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (9,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (9,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (9,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('No Partner Grant Payment Request Activity','Actionable Alerts');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (10,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (10,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (10,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (10,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (10,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (10,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('No Project Payment Request Activity','Actionable Alerts');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (11,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (11,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (11,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (11,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (11,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (11,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Overdue Payment Request','Actionable Alerts');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (12,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (12,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (12,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (12,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (12,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (12,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Partner Grant Signature Not Received','Actionable Alerts');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (13,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (13,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (13,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (13,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (13,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (13,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Partner Grants Funds Changed','Change Notifications');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (14,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (14,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (14,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (14,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (14,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (14,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Past Due IMP','Actionable Alerts');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (15,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (15,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (15,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (15,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (15,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (15,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Payment Request Status Changed','Change Notifications');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (16,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (16,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (16,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (16,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (16,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (16,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Project End Date Changed','Change Notifications');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (17,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (17,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (17,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (17,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (17,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (17,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Project Management Funds Changed','Change Notifications');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (18,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (18,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (18,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (18,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (18,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (18,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Project Start Date Changed','Change Notifications');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (19,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (19,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (19,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (19,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (19,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (19,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Project Status Changed','Change Notifications');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (20,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (20,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (20,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (20,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (20,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (20,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Rejected Payment Request','Actionable Alerts');-- 1,2,3,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (21,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (21,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (21,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (21,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (21,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (21,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('EDIT link','Donor - View');-- 1,2,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (22,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (22,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (22,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (22,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (22,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('EDIT button','Donor - View');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (23,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (23,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('EDIT link','Donor Award');-- 1,2,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (24,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (24,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (24,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (24,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (24,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('EDIT button','Donor Award - View');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (25,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (25,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('View Related Project','Project - Summary View');-- 1,2,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (26,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (26,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (26,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (26,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (26,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('View Project Details','Project - Detailed View');-- 1,2,4,5,6,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (27,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (27,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (27,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (27,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (27,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('EDIT button','Project - Detailed View');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (28,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (28,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('View link','Partner Grant - View');-- 1,2,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (29,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (29,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (29,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (29,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (29,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('EDIT button','Partner Grant - View');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (30,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (30,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Add Partner button','Partner - Add');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (31,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (31,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Field Editing Allowed - Period Start Date (Narrative Section)','Reporting Requirements');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (32,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (32,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Field Editing Allowed - Period End Date (Narrative Section)','Reporting Requirements');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (33,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (33,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Field Editing Allowed - Due Date (Narrative Section)','Reporting Requirements');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (34,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (34,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Field Editing Allowed - Received Date (Narrative Section)','Reporting Requirements');-- 1,4,5,
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (35,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (35,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (35,5);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Field Editing Allowed - Final? (Narrative Section)','Reporting Requirements');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (36,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (36,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Field Editing Allowed - Period Start Date (Financial Section)','Reporting Requirements');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (37,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (37,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Field Editing Allowed - Period End Date (Financial Section)','Reporting Requirements');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (38,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (38,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Field Editing Allowed - Due Date (Financial Section)','Reporting Requirements');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (39,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (39,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Field Editing Allowed - Received Date (Financial Section)','Reporting Requirements');-- 1,2,4,5
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (40,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (40,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (40,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (40,5);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Field Editing Allowed - Final? (Financial Section)','Reporting Requirements');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (41,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (41,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Field Editing Allowed - To Grants (Financial Section)','Reporting Requirements');-- 1,4,5
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (42,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (42,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (42,5);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Field Editing Allowed - Received in Grants (Financial Section)','Reporting Requirements');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (43,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (43,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Field Editing Allowed - Approved? (Financial Section)','Reporting Requirements');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (44,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (44,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('ADD ROW button (Narrative section)','Reporting Requirements');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (45,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (45,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('DELETE SELECTED button (Narrative section)','Reporting Requirements');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (46,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (46,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('ADD ROW button (Financial section)','Reporting Requirements');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (47,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (47,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('DELETE SELECTED button (Financial section)','Reporting Requirements');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (48,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (48,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('ENTER PARTNER MONITORING INFORMATION button','Reporting Requirements');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (49,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (49,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('EDIT button','Partner Monitoring');-- 1,2
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (50,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (50,2);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('PROCESS PAYMENT button','Add Payment Request');-- 1,3
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (51,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (51,3);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('PROCESSING button','View - Payment Request');,-- 1,3
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (52,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (52,3);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('REQUEST ID link','View - Payment Request');-- 1,2,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (53,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (53,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (53,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (53,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (53,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Add/Edit button', 'Payee - Add');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (54,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (54,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (54,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (54,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (54,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (54,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('View link','Project Catalogue (View)');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (55,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (55,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (55,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (55,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (55,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (55,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('EDIT button','Project Catalogue');-- 1,5
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (56,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (56,5);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Project Status = "Active"','Projects and Grants');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (57,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (57,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (57,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (57,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (57,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (57,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Project Status = "Over"','Projects and Grants');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (58,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (58,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (58,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (58,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (58,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (58,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Projects "Over" within 30 days','Projects and Grants');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (59,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (59,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (59,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (59,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (59,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (59,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('New Projects where no Payment Activity >= 60 days','Projects and Grants');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (60,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (60,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (60,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (60,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (60,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (60,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('"Active" Projects with more than 90% Budget Disbursed','Projects and Grants'); -- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (61,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (61,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (61,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (61,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (61,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (61,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Partner Grant Status = "Active"','Projects and Grants');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (62,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (62,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (62,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (62,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (62,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (62,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Partner Grant Status = "Over"','Projects and Grants');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (63,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (63,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (63,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (63,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (63,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (63,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('New Partner Grants where Signed Grant Agreement Not Received.','Projects and Grants');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (64,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (64,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (64,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (64,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (64,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (64,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('New Partner Grants with no Payment Activity greater >= 60 days.','Projects and Grants');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (65,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (65,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (65,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (65,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (65,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (65,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('"Active" Partner Grants with more than 90% Budget Disbursed','Projects and Grants');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (66,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (66,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (66,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (66,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (66,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (66,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('# of Open Payment Requests',1,'Payment Processing');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (67,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (67,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (67,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (67,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (67,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (67,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Payment Requests that have been open for greater than 30 days','Payment Processing');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (68,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (68,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (68,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (68,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (68,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (68,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Paid Payment Requests, past 30 days','Payment Processing');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (69,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (69,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (69,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (69,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (69,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (69,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('# Rejected Payment Requests','Payment Processing');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (70,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (70,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (70,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (70,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (70,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (70,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Narrative Reports due within 30 days','Partner Monitoring');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (71,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (71,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (71,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (71,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (71,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (71,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Financial Reports due within 30 days','Partner Monitoring');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (72,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (72,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (72,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (72,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (72,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (72,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Narrative Reports Past Due','Partner Monitoring');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (73,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (73,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (73,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (73,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (73,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (73,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Financial Reports Past Due','Partner Monitoring');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (74,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (74,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (74,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (74,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (74,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (74,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('IMPs due within 30 days','Partner Monitoring');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (75,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (75,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (75,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (75,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (75,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (75,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('IMPs Past Due','Partner Monitoring');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (76,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (76,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (76,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (76,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (76,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (76,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Auditor Analysis & Selection Sheets (AASS) due within 30 days','Partner Monitoring');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (77,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (77,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (77,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (77,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (77,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (77,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Auditor Analysis & Selection Sheets (AASS) Past Due','Partner Monitoring');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (78,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (78,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (78,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (78,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (78,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (78,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Interim Audits Due within 30 days','Partner Monitoring');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (79,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (79,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (79,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (79,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (79,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (79,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Final Audits Due within 30 days','Partner Monitoring');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (80,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (80,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (80,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (80,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (80,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (80,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Interim Audit Date Past Due','Partner Monitoring');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (81,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (81,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (81,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (81,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (81,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (81,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Final Audit Date Past Due','Partner Monitoring');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (82,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (82,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (82,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (82,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (82,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (82,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('New Donor Awards (less than 30 days old)','Donor and donor awards');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (83,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (83,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (83,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (83,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (83,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (83,6);
--INSERT INTO [restricteduielements] ([nameorvalue],[submenuorform]) VALUES ('Donor Awards "Over" in less than 90 days','Donor and donor awards');-- 1,2,3,4,5,6
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (84,1);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (84,2);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (84,3);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (84,4);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (84,5);
INSERT INTO [restricteduielements_roleprivileges] ([uielementid],[roleid]) VALUES (84,6);

GO